关键词: 数据仓库, SQL Server, 联机分析处理, 数据挖掘, 联机分析挖掘, 聚类分析

Abstract: OLAM (On-line Analytical Mining) is current hot technology and a new mining method which fuses the advantages of OLAP and data mining. This paper focuses on the OLAP and data mining technology which are the core technologies and primary content of business intelligence. OLAM is introduced on the basis of the two technologies, and the basic principles and core technologies are expounded. A data warehouse for a business case is built based on SQL Server platform, and a sales cube is built by OLAP using Analysis Services. The combination of OLAP and clustering mining is realized by means of OLAM model, the conclusion is that a good clustering result of customer is obtained with the aid of superiority of OLAP and clustering mining.

Key words: data warehouse, SQL Server, OLAP, data mining, OLAM, clustering analysis